[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '143' >
4 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SalariedFlag | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106 | 13.4615 | 1975-10-22 | Finance | david5@adventure-works.com | David Barber | 477-555-0132 | 231203233 | David | M | 2020-05-14 | Barber | adventure-works\david5 | S | M | 143 | 2 | 477-555-0132 | | 48 | 2020-05-14 | Current | Assistant to the Chief Financial Officer | 56 | |
| 142 | 34.7356 | 1994-11-07 | Finance | david6@adventure-works.com | David Liu | 646-555-0185 | 30845 | David | M | 2020-06-01 | Liu | adventure-works\david6 | M | J | 143 | 2 | 646-555-0185 | | 1 | 48 | 2020-06-01 | Current | Accounts Manager | 57 |
| 32 | 27.1394 | 1987-06-13 | Human Resources | paula0@adventure-works.com | Paula Barreto de Mattos | 523-555-0175 | 535145551 | Paula | F | 2020-04-07 | Barreto de Mattos | adventure-works\paula0 | M | M | 143 | 2 | 523-555-0175 | | 1 | 47 | 2020-04-07 | Current | Human Resources Manager | 54 |
| 73 | 43.2692 | 1996-02-11 | Finance | wendy0@adventure-works.com | Wendy Kahn | 248-555-0134 | 121491555 | Wendy | F | 2020-04-26 | Kahn | adventure-works\wendy0 | S | Beth | 143 | 2 | 248-555-0134 | | 1 | 47 | 2020-04-26 | Current | Finance Manager | 55 |
Generated 2025-10-30 12:34:23.741 UTC